<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0076)http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/ -->
<html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br"><script src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/quant.js" async="" type="text/javascript"></script><script type="text/javascript">window["_gaUserPrefs"] = { ioo : function() { return true; } }</script><head profile="http://gmpg.org/xfn/11"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Executando comandos SQL no CakePHP «  Alberane Lúcio</title>
<link rel="stylesheet" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/style.css" type="text/css" media="screen" title="Freshy">
<!--[if IE 7]>
	<link rel="stylesheet" href="http://s0.wp.com/wp-content/themes/pub/freshy/ie7.css?m=1285366787g" type="text/css" media="screen" />
<![endif]-->
<!--[if lt IE 7]>
	<link rel="stylesheet" href="http://s0.wp.com/wp-content/themes/pub/freshy/ie6.css?m=1323834012g" type="text/css" media="screen" />
<![endif]-->
<link rel="pingback" href="http://alberane.wordpress.com/xmlrpc.php">
<link rel="alternate" type="application/rss+xml" title="Feed de Alberane Lúcio »" href="http://alberane.wordpress.com/feed/">
<link rel="alternate" type="application/rss+xml" title="Alberane Lúcio »  Feed de comentários" href="http://alberane.wordpress.com/comments/feed/">
<link rel="alternate" type="application/rss+xml" title="Alberane Lúcio » Executando comandos SQL no CakePHP  Feed de comentários" href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/feed/">
<script type="text/javascript">
/* <![CDATA[ */
function addLoadEvent(func){var oldonload=window.onload;if(typeof window.onload!='function'){window.onload=func;}else{window.onload=function(){oldonload();func();}}}
/* ]]> */
</script>
<link rel="stylesheet" id="all-css-0" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/saved_resource" type="text/css" media="all">
<link rel="stylesheet" id="print-css-0" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/global-print.css" type="text/css" media="print">
<script type="text/javascript">
/* <![CDATA[ */
var LoggedOutFollow = {"invalid_email":"Sua assinatura n\u00e3o foi bem sucedida, por favor, tente novamente com um endere\u00e7o de email v\u00e1lido."};
/* ]]> */
</script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/saved_resource(1)"></script>
<link rel="stylesheet" id="all-css-0" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/style(1).css" type="text/css" media="all">
<!--[if lt IE 8]>
<link rel='stylesheet' id='highlander-comments-ie7-css'  href='http://s2.wp.com/wp-content/mu-plugins/highlander-comments/style-ie7.css?m=1351637563g&#038;ver=20110606' type='text/css' media='all' />
<![endif]-->
<link rel="EditURI" type="application/rsd+xml" title="RSD" href="http://alberane.wordpress.com/xmlrpc.php?rsd">
<link rel="wlwmanifest" type="application/wlwmanifest+xml" href="http://alberane.wordpress.com/wp-includes/wlwmanifest.xml"> 
<link rel="prev" title="Redes De Computadores – Parte 3" href="http://alberane.wordpress.com/2009/03/16/redes-de-computadores-parte-3/">
<link rel="next" title="Ubuntu Sem Som" href="http://alberane.wordpress.com/2010/01/07/ubuntu-sem-som/">
<meta name="generator" content="WordPress.com">
<link rel="canonical" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/Executando comandos SQL no CakePHP « Alberane Lúcio.htm">
<link rel="shortlink" href="http://wp.me/p228E-I">
<link rel="alternate" type="application/json+oembed" href="http://public-api.wordpress.com/oembed/1.0/?format=json&url=http%3A%2F%2Falberane.wordpress.com%2F2009%2F05%2F08%2Fexecutando-comandos-sql-no-cakephp%2F&for=wpcom-auto-discovery"><link rel="alternate" type="application/xml+oembed" href="http://public-api.wordpress.com/oembed/1.0/?format=xml&url=http%3A%2F%2Falberane.wordpress.com%2F2009%2F05%2F08%2Fexecutando-comandos-sql-no-cakephp%2F&for=wpcom-auto-discovery">
<!-- Jetpack Open Graph Tags -->
<meta property="og:type" content="article">
<meta property="og:title" content="Executando comandos SQL no CakePHP">
<meta property="og:url" content="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/">
<meta property="og:description" content="Estou desenvolvendo um software com a finalidade de alimentar e ou sincronizar bancos de dados. Ele deve fazer o seguinte, quando o usuário acessar a url (http://www.site.com.br/sincronizacoes/sinc...">
<meta property="og:site_name" content="Alberane Lúcio">
<meta name="twitter:site" content="@wordpressdotcom">
<meta name="twitter:card" content="summary">
<meta property="fb:app_id" content="249643311490">
<link rel="shortcut icon" type="image/x-icon" href="http://s2.wp.com/i/favicon.ico?m=1311975824g" sizes="16x16 24x24 32x32 48x48">
<link rel="icon" type="image/x-icon" href="http://s2.wp.com/i/favicon.ico?m=1311975824g" sizes="16x16 24x24 32x32 48x48">
<link rel="apple-touch-icon-precomposed" href="http://s0.wp.com/i/webclip.png?m=1311618091g">
<link rel="openid.server" href="http://alberane.wordpress.com/?openidserver=1">
<link rel="openid.delegate" href="http://alberane.wordpress.com/">
<link rel="search" type="application/opensearchdescription+xml" href="http://alberane.wordpress.com/osd.xml" title="Alberane Lúcio">
<link rel="search" type="application/opensearchdescription+xml" href="http://wordpress.com/opensearch.xml" title="WordPress.com">
		<style>
		/* <![CDATA[ */
		/* Block: reblog */
		
		.reblog-from img                   { margin: 0 10px 0 0; vertical-align: middle; padding: 0; border: 0; }
		.reblogger-note img.avatar         { float: left; padding: 0; border: 0; }
		.reblogger-note-content            { margin: 0 0 20px; }
		.reblog-post .wpcom-enhanced-excerpt-content { border-left: 3px solid #eee; padding-left: 15px; }
		.reblog-post ul.thumb-list         { display: block; list-style: none; margin: 2px 0; padding: 0; clear: both; }
		.reblog-post ul.thumb-list li      { display: inline; margin: 0; padding: 0 1px; border: 0; }
		.reblog-post ul.thumb-list li a    { margin: 0; padding: 0; border: 0; }
		.reblog-post ul.thumb-list li img  { margin: 0; padding: 0; border: 0; }
		
		.reblog-post .wpcom-enhanced-excerpt { clear: both; }
		
		.reblog-post .wpcom-enhanced-excerpt address,
		.reblog-post .wpcom-enhanced-excerpt li,
		.reblog-post .wpcom-enhanced-excerpt h1,
		.reblog-post .wpcom-enhanced-excerpt h2,
		.reblog-post .wpcom-enhanced-excerpt h3,
		.reblog-post .wpcom-enhanced-excerpt h4,
		.reblog-post .wpcom-enhanced-excerpt h5,
		.reblog-post .wpcom-enhanced-excerpt h6,
		.reblog-post .wpcom-enhanced-excerpt p { font-size: 100% !important; }
		
		.reblog-post .wpcom-enhanced-excerpt blockquote,
		.reblog-post .wpcom-enhanced-excerpt pre,
		.reblog-post .wpcom-enhanced-excerpt code,
		.reblog-post .wpcom-enhanced-excerpt q { font-size: 98% !important; }
		

		/* ]]> */		
		</style>
		
	<style type="text/css">
	.menu.primary li a {
		background-image:url("http://s0.wp.com/wp-content/themes/pub/freshy/images/menu/menu_triple.gif?m=1171163464g");
	}
	.menu.primary li a.first_menu {
		background-image:url("http://s0.wp.com/wp-content/themes/pub/freshy/images/menu/menu_start_triple.gif?m=1171163464g");
	}
	.menu.primary li a.last_menu {
		background-image:url("http://s0.wp.com/wp-content/themes/pub/freshy/images/menu/menu_end_triple.gif?m=1171163464g");
	}

	.description {
		color:#ADCF20;
	}
	#content .commentlist dd.author_comment {
		background-color:#a3cb00 !important;
	}
	html > body #content .commentlist dd.author_comment {
		background-color:#a3cb00 !important;
	}
	#content .commentlist dt.author_comment .date {
		color:#a3cb00 !important;
		border-color:#a3cb00 !important;
	}
	#content .commentlist .author_comment .author,
	#content .commentlist .author_comment .author a {
		color:#a3cb00 !important;
		border-color:#a3cb00 !important;
	}
	#sidebar h2 {
		color:#f78b0c;
		background-color:#FFFFFF;
		border-bottom-color:#f78b0c;
	}
	#sidebar {
		background-color:#FFFFFF;
	}
	*::-moz-selection {
		background-color:#FF3C00;
	}

	#content a:hover {
		border-bottom:1px dotted #FF3C00;
	}

	#sidebar a:hover,
	#sidebar .current_page_item li a:hover,
	#sidebar .current-cat li a:hover,
	#sidebar .current_page_item a,
	#sidebar .current-cat a ,
	.readmore,
	#content .postmetadata a
	{
		color : #FF3C00;
	}

	#title_image {
		margin:0;
		text-align:left;
		display:block;
		height:95px;
	}

	</style>

	<meta name="application-name" content="Alberane Lúcio"><meta name="msapplication-window" content="width=device-width;height=device-height"><meta name="msapplication-tooltip" content="...no caos, me sinto à vontade."><meta name="msapplication-task" content="name=Assinar;action-uri=http://alberane.wordpress.com/feed/;icon-uri=http://s2.wp.com/i/favicon.ico"><meta name="msapplication-task" content="name=Cadastre-se para um blog gratuito;action-uri=http://wordpress.com/signup/;icon-uri=http://s2.wp.com/i/favicon.ico"><meta name="msapplication-task" content="name=Suporte WordPress.com;action-uri=http://support.wordpress.com/;icon-uri=http://s2.wp.com/i/favicon.ico"><meta name="msapplication-task" content="name=Fóruns WordPress.com;action-uri=http://forums.wordpress.com/;icon-uri=http://s2.wp.com/i/favicon.ico"><meta name="title" content="Executando comandos SQL no CakePHP | Alberane Lúcio on WordPress.com">
<meta name="description" content="Estou desenvolvendo um software com a finalidade de alimentar e ou sincronizar bancos de dados. Ele deve fazer o seguinte, quando o usuário acessar a url (http://www.site.com.br/sincronizacoes/sinc) o sistema lê vários bancos e várias tabelas, analisa algumas condições, prepara os dados e alimenta algumas tabelas de com esses dados.">
<style type="text/css">
	#title_image {
	background-image:url(http://alberane.files.wordpress.com/2007/05/cropped-14343856.jpg);
	}
</style>

<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/google_service.js">
</script>
<script type="text/javascript">
GS_googleAddAdSenseService("ca-pub-3443918307802676");
GS_googleEnableAllServices();
</script><script src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/google_ads.js"></script>
<script type="text/javascript">
GA_googleAddSlot("ca-pub-3443918307802676", "wpcom_below_post");
</script>
<script type="text/javascript">
GA_googleFetchAds();
</script>
<script type="text/javascript"> 
	window.google_analytics_uacct = "UA-52447-2"; 
</script>

<script type="text/javascript">
	var _gaq = _gaq || [];
	_gaq.push(['_setAccount', 'UA-52447-2']);
	_gaq.push(['_setDomainName', 'wordpress.com']);
	_gaq.push(['_initData']);
	_gaq.push(['_trackPageview']);

	(function() {
		var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
		ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
		(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga);
	})();
</script><script type="text/javascript" async="" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/ga.js"></script>
<link rel="stylesheet" type="text/css" id="gravatar-card-css" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/hovercard.css"><link rel="stylesheet" type="text/css" id="gravatar-card-services-css" href="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/services.css"><script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/osd.js"></script></head>
<body class="single single-post postid-44 single-format-standard highlander-enabled highlander-light" data-twttr-rendered="true">

<div id="page">
		<div id="wrapper">
		<!-- header -->
		<div id="header">
			<div id="title">
				<h1>
					<a href="http://alberane.wordpress.com/">
						<span>Alberane Lúcio</span>
					</a>
				</h1>
				<div class="description">
					<small>…no caos, me sinto à vontade.</small>
				</div>
			</div>
			<div id="title_image"></div>
		</div>

		<!-- main div -->
		<div id="frame">

		<!-- main menu -->
		<ul class="menu page-menu primary">
	<li class="page_item">
		<a class="first_menu" href="http://alberane.wordpress.com/">
			Início		</a>
	</li>

	<li class="page_item"><a href="http://alberane.wordpress.com/sobre/" title="Sobre">Sobre</a></li>
<li class="page_item"><a href="http://alberane.wordpress.com/contato/" title="Contato">Contato</a></li>

	<li class="last_menu">
		<!-- put an empty link to have the end of the menu anyway -->
		<a class="last_menu_off"></a>
	</li>
</ul>

		<hr style="display:none">

	<div id="content">

	
		
			<div class="post-44 post type-post status-publish format-standard hentry category-artigos category-php-cakephp" id="post-44">

				<h2>Executando comandos SQL no&nbsp;CakePHP</h2>

				<small class="date">
					<span class="date_day">8</span>
					<span class="date_month">05</span>
					<span class="date_year">2009</span>
				</small>

				<div class="entry">
					<p>Depois de muito pesquisar e me irritar com uma coisa que parece ser tão básica resolvi postar aqui o que eu tive dificuldades para encontrar na internet.</p>
<p>Eis o cenário:</p>
<blockquote><p>Estou desenvolvendo um software com a finalidade de alimentar e ou sincronizar bancos de dados. Ele deve fazer o seguinte, quando o usuário acessar a url (http://www.site.com.br/sincronizacoes/sinc) o sistema lê vários bancos e várias tabelas, analisa algumas condições, prepara os dados e alimenta algumas tabelas de com esses dados.</p></blockquote>
<p>Alguns adeptos do CakePHP poderiam dizer… “porque vc não usa o find()…. porque vc não usa os relacionamentos do Cake….etc…etc…”. Tudo bem! Acho até que seria possivel fazer com mais alguns dias de estudo do cake.</p>
<p>O problema é que não tinha esses dias e eu REALMENTE gostaria de usar as minhas queryes.</p>
<p>Porque?… São queryes enormes e eu já as tenho todas prontas, eu não queria reescrever tudo.</p>
<p>Como eu disse, é um processo simples mas acabei não encontrando uma documentação nem um relato preciso para o que eu queria. então vamos lá!</p>
<p>Como executar um comando SQL qualquer usando o Cake e obter o seu resultado</p>
<p>1)&nbsp; Crie o seu controller:</p>
<pre>class SincronizacoesController extends AppController {
 var $uses = array("Sincronizacao");
 function index(){
 }
 function sinc(){
 $this-&gt;set('vw_dados',$this-&gt;Sincronizacao-&gt;<span style="color:#339966;">executaSinc</span>());
 }
}</pre>
<p>2) Crie o seu model:</p>
<pre>class Sincronizacao extends AppModel{

<span style="color:#ff0000;">&nbsp;<span style="color:#3366ff;"><strong>var $useTable = false; </strong>      

    # Esse é o segredo....
    # o seu model não vai usar nenhuma tabela...
    # apenas a conexão com o banco</span>

</span> function index(){

 }

 public function <span style="color:#339966;">executaSinc</span>(){
     return($this-&gt;query("<span style="color:#3366ff;">Execute aqui qualquer comando SQL que desejar</span>"));
 }
}</pre>
<p>Por fim, crie o view normalmente e trate os dados nele</p>
<pre><span style="color:#00ccff;">&lt;h1&gt;</span>Ufa!<span style="color:#00ccff;">&lt;/h1&gt;</span>
<span style="color:#00ccff;">&lt;b&gt;</span>
 <span style="color:#800000;">&lt;?php</span> pr($vw_dados); <span style="color:#800000;">?&gt;</span>
<span style="color:#00ccff;">&lt;/b&gt;</span></pre>
<p>Pronto!… muito simples… mas se alguém não explicar fica complicado de se adivinhar. <img src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/icon_wink.gif" alt=";)" class="wp-smiley"> </p>
<p>Até a próxima</p>

<div class="wpadvert" style="position: relative; width:300px; text-align: center; padding: 0; margin: 10px auto; overflow: hidden;">
<a style="position: absolute; text-align: left; display: block; font: 9px/1 sans-serif; text-decoration: underline;" href="http://en.wordpress.com/about-these-ads/" rel="nofollow">About these ads</a>
<script type="text/javascript">
GA_googleAddAttr("AdOpt", "1");
GA_googleAddAttr("Origin", "other");
GA_googleAddAttr("LangId", "438");
GA_googleAddAttr("Domain", "alberane.wordpress.com");
GA_googleAddAttr("BlogId", "484880");
GA_googleAddAttr("Tag", "artigos");
GA_googleAddAttr("Tag", "php-cakephp");
GA_googleAddAttr("theme_bg", "ffffff"); 
GA_googleAddAttr("theme_border", "cccccc"); 
GA_googleAddAttr("theme_text", "000000"); 
GA_googleAddAttr("theme_link", "515151"); 
GA_googleAddAttr("theme_url", "f78b0c"); 
GA_googleAddAdSensePageAttr("google_page_url", "http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/");
GA_googleFillSlot("wpcom_below_post");
</script><script src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/ads"></script><div id="google_ads_div_wpcom_below_post_ad_wrapper">
<div id="google_ads_div_wpcom_below_post_ad_container" style="display:inline-block;"><!-- BEGIN IFRAME TAG - WordAd - 300x250 < - DO NOT MODIFY -->
<iframe src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/tt.htm" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" allowtransparency="true" width="300" height="250"></iframe>
<!-- END TAG -->

</div>
</div>

</div>
<style type="text/css">
div.wpadvert>div { margin-top: 1em; }
</style>
<script type="text/javascript">
jQuery( window ).load( function() {
    if ( jQuery(".wpadvert script[src*='shareth.ru']").length > 0 || jQuery(".wpadvert .sharethrough-placement").length > 0 ) {
        jQuery( '.wpadvert' ).css( 'width', '400px' );
    }
setTimeout(function(){if(typeof GS_googleAddAdSenseService !== 'function'){new Image().src=document.location.protocol+"//stats.wordpress.com/g.gif?v=wpcom-no-pv&x_noads=adblock&baba="+Math.random()}},100);
} );
</script>
<div id="jp-post-flair" class="sharedaddy sd-like-enabled"><div class="wpl-likebox sd-block sd-like"><h3 class="sd-title">Gostar disso:</h3><div class="sd-content"><div id="like-44" class="wpl-button "><a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/?like=1&_wpnonce=67418a1937" title="Gostei." class="like needs-login sd-button" rel="nofollow"><span>Gostei</span></a></div><div class="wpl-count sd-like-count">Seja o primeiro a gostar disso.</div></div></div></div>				</div>

				
			</div>

			<p class="navigation">
				<span class="alignleft">« <a href="http://alberane.wordpress.com/2009/03/16/redes-de-computadores-parte-3/" rel="prev">Redes De Computadores – Parte&nbsp;3</a></span>
				<span class="alignright"><a href="http://alberane.wordpress.com/2010/01/07/ubuntu-sem-som/" rel="next">Ubuntu Sem&nbsp;Som</a> »</span>
			</p>
			<br>
			<h3>Ações</h3>
			<ul class="postmetadata">
					<li class="with_icon"><img class="icon" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/feed-icon-16x16.gif" alt="rss">&nbsp;<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/feed/">RSS Comentários</a></li>
							<li class="with_icon"><img class="icon" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/trackback-icon-16x16.gif" alt="trackback">&nbsp;<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/trackback/" rel="trackback" title="make a trackback">Trackback</a></li>
							</ul>

			<h3>Informação</h3>
			<ul class="postmetadata">
					<!--<li>Autor : alberane</li>-->
					<li>Data : 08 maio, 2009</li>
									<li></li>
					<li>Categorias : <a href="http://alberane.wordpress.com/category/artigos/" title="Ver todos os posts em Artigos" rel="category tag">Artigos</a>, <a href="http://alberane.wordpress.com/category/tutoriais/php-cakephp/" title="Ver todos os posts em PHP CakePHP" rel="category tag">PHP CakePHP</a></li>
							</ul>

				<h3 id="comments">3 respostas</h3>

	<dl class="commentlist">
	
	<dt class=" none">
		<small class="date">
			<span class="date_day">25</span>
			<span class="date_month">05</span>
			<span class="date_year">2010</span>
		</small>
	</dt>

	<dd class="comment even thread-even depth-1 commentlist_item parent highlander-comment" id="comment-30">

		<div class="comment" id="div-comment-30">
			<strong class="comment-author vcard author" style="height:32px;line-height:32px;">
			<img alt="" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/6d14de4f8a572b54ec67d34ee92bf742" class="avatar avatar-32 grav-hashed grav-hijack" height="32" width="32" id="grav-6d14de4f8a572b54ec67d34ee92bf742-0">
			<span class="fn">Tarciso</span></strong> <span class="comment-meta commentmetadata"><small>(15:01:21)</small> : </span>
			
			<br style="display:none;">

			<div class="comment_text">
			<p>Também andei apanhando pra isso no cake.. no meu caso eu peguei um site iniciado, mas só tinha alguns cadastros, qdo precisei rodar uma consulta minha, foi aquele sofrimento… rsrrsr  </p>
<p>  legal a dica do $useTable=false; não sabia, eu estava declarando as funções no modulo de outras tabelas;</p>
			</div>
			<div class="reply">
				<a class="comment-reply-link" href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/?replytocom=30#respond" onclick="return addComment.moveForm(&quot;div-comment-30&quot;, &quot;30&quot;, &quot;respond&quot;, &quot;44&quot;)">Comentar</a>			</div>
		</div>
	</dd>

	<dt class=" none">
		<small class="date">
			<span class="date_day">9</span>
			<span class="date_month">09</span>
			<span class="date_year">2010</span>
		</small>
	</dt>

	<dd class="comment odd alt depth-2 commentlist_item parent highlander-comment" id="comment-32">

		<div class="comment" id="div-comment-32">
			<strong class="comment-author vcard author" style="height:32px;line-height:32px;">
			<img alt="" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/a4e4fd831fad341f603d6d3c3516e753" class="avatar avatar-32 grav-hashed grav-hijack" height="32" width="32" id="grav-a4e4fd831fad341f603d6d3c3516e753-0">
			<span class="fn">Marcelo Martins</span></strong> <span class="comment-meta commentmetadata"><small>(00:07:28)</small> : </span>
			
			<br style="display:none;">

			<div class="comment_text">
			<p>Olá amigos, estou iniciando no Cake e gostaria de saber como executo o site, ou melhor, o formulário de preenchimento de cadastro de usuario.<br>
Estou seguindo um tutorial da IBM , e a dica lá é para lançar da seguinte forma:</p>
<p>Experimente</p>
<p>Todas as partes se encaixaram no devido lugar. É hora de trazer Tor para a vida. Inicie seu navegador e comece.</p>
<p>Carregue a visualização de registro acessando <a href="http://localhost/users/register" rel="nofollow">http://localhost/users/register</a>. Você deverá ver algo semelhante à Figura 4.</p>
<p>Mas , ocorre a seguinte msg no browser:</p>
<p>Not Found</p>
<p>The requested URL /users/register was not found on this server.</p>
<p>Alguém tem uma dica ? Como executar um ficheiro com a extensão *.ctp ?</p>
			</div>
			<div class="reply">
				<a class="comment-reply-link" href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/?replytocom=32#respond" onclick="return addComment.moveForm(&quot;div-comment-32&quot;, &quot;32&quot;, &quot;respond&quot;, &quot;44&quot;)">Comentar</a>			</div>
		</div>
	</dd>

	<dt class=" author_comment">
		<small class="date">
			<span class="date_day">10</span>
			<span class="date_month">09</span>
			<span class="date_year">2010</span>
		</small>
	</dt>

	<dd class="comment even depth-3 commentlist_item highlander-comment" id="comment-33">

		<div class="comment" id="div-comment-33">
			<strong class="comment-author vcard author" style="height:32px;line-height:32px;">
			<img alt="" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/13afd943e915547000950ea34bf67de1" class="avatar avatar-32 grav-hashed grav-hijack" height="32" width="32" id="grav-13afd943e915547000950ea34bf67de1-0">
			<span class="fn">Alberane</span></strong> <span class="comment-meta commentmetadata"><small>(00:16:16)</small> : </span>
			
			<br style="display:none;">

			<div class="comment_text">
			<p>Olá Marcelo,</p>
<p>Confira as configurações do seu arquivo .htacces, pela sua descrição não foi possível confirmar qual servidor está usando e em qual sistema operacional.</p>
<p>verifique se seu servidor (Apache/IIS/etc) está configurado corretamente com rewrite_mod.</p>
<p>Os arquivos .ctp são os arquivos de templates do cake… não será necessário acessá-los ou executá-los. Internamente o cake fará isso pra você.</p>
<p>Basicamente os arquivo .ctp são arquivos html/css/php normais… apenas a extensão é diferente, mera padronização do cake.</p>
			</div>
			<div class="reply">
							</div>
		</div>
	</dd>
	</dl>
	<div class="navigation">
		<div class="alignleft"></div>
		<div class="alignright"></div>
	</div>


								<div id="respond" class="js">
				<h3 id="reply-title">Deixe uma resposta <small><a rel="nofollow" id="cancel-comment-reply-link" href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#respond" style="display:none;">Cancelar resposta</a></small></h3>
									<form action="http://alberane.wordpress.com/wp-comments-post.php" method="post" id="commentform">
																										


												
<input type="hidden" name="hc_post_as" id="hc_post_as" value="guest">

<div class="comment-form-field comment-textarea">
	
	<div id="comment-form-comment"><textarea placeholder="Escreva o seu comentário aqui..." style="height: 38px; resize: none; overflow-y: hidden; position: absolute; top: 0px; left: -9999px; width: 488px; line-height: 18.200000762939453px; text-decoration: initial; letter-spacing: 0px;" tabindex="-1"></textarea><textarea id="comment" name="comment" placeholder="Escreva o seu comentário aqui..." style="height: 38px; resize: none; overflow-y: hidden;"></textarea></div>
</div>

<div id="comment-form-identity" style="display: none;">

	<div id="comment-form-nascar">
		<p>Preencha os seus dados abaixo ou clique em um ícone para log in:</p>
		<ul>
			<li class="selected" style="display:none;">
				<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#comment-form-guest" id="postas-guest" title="Convidado">
					<span></span>
				</a>
			</li>
			<li>
				<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#comment-form-load-service:WordPress.com" id="postas-wordpress" title="WordPress.com">
					<span></span>
				</a>
			</li>
			<li>
				<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#comment-form-load-service:Twitter" id="postas-twitter" title="Twitter">
					<span></span>
				</a>
			</li>
			<li>
				<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#comment-form-load-service:Facebook" id="postas-facebook" title="Facebook">
					<span></span>
				</a>
			</li>
		</ul>
	</div>

	<div id="comment-form-guest" class="comment-form-service selected">
		<div class="comment-form-padder">
			<div class="comment-form-avatar">
<a href="https://gravatar.com/site/signup/" target="_blank">				<img src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/ad516503a11cd5ca435acc9bb6523536" alt="Gravatar" width="25" class="no-grav">
</a>			</div>

				<div class="comment-form-fields">
				<div class="comment-form-field comment-form-email">
					<label for="email">Email <span class="required">(obrigatório)</span> <span class="nopublish">(Address never made public)</span></label>
					<div class="comment-form-input"><input id="email" name="email" type="email" value=""></div>
				</div>
				<div class="comment-form-field comment-form-author">
					<label for="author">Nome <span class="required">(obrigatório)</span></label>
					<div class="comment-form-input"><input id="author" name="author" type="text" value=""></div>
				</div>
				<div class="comment-form-field comment-form-url">
					<label for="url">Site</label>
					<div class="comment-form-input"><input id="url" name="url" type="text" value=""></div>
				</div> 
			</div>
	
		</div>
	</div>

	<div id="comment-form-wordpress" class="comment-form-service">
		<div class="comment-form-padder">
			<div class="comment-form-avatar">
				<img src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/wplogo.png" alt="WordPress.com Logo" width="25" class="no-grav">
			</div>

				<div class="comment-form-fields">
				<input type="hidden" name="wp_avatar" id="wordpress-avatar" class="comment-meta-wordpress" value="">
				<input type="hidden" name="wp_user_id" id="wordpress-user_id" class="comment-meta-wordpress" value="">
				<input type="hidden" name="wp_access_token" id="wordpress-access_token" class="comment-meta-wordpress" value="">
				<p class="comment-form-posting-as pa-wordpress"><strong></strong> You are commenting using your WordPress.com account. <span class="comment-form-log-out">(&nbsp;<a href="javascript:HighlanderComments.doExternalLogout( 'wordpress' );">Sair</a>&nbsp;/&nbsp;<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#" onclick="javascript:HighlanderComments.switchAccount();return false;">Alterar</a>&nbsp;)</span></p>
			</div>
	
		</div>
	</div>

	<div id="comment-form-twitter" class="comment-form-service">
		<div class="comment-form-padder">
			<div class="comment-form-avatar">
				<img src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/ad516503a11cd5ca435acc9bb6523536" alt="Imagem do Twitter" width="25" class="no-grav">
			</div>

				<div class="comment-form-fields">
				<input type="hidden" name="twitter_avatar" id="twitter-avatar" class="comment-meta-twitter" value="">
				<input type="hidden" name="twitter_user_id" id="twitter-user_id" class="comment-meta-twitter" value="">
				<input type="hidden" name="twitter_access_token" id="twitter-access_token" class="comment-meta-twitter" value="">
				<p class="comment-form-posting-as pa-twitter"><strong></strong> You are commenting using your Twitter account. <span class="comment-form-log-out">(&nbsp;<a href="javascript:HighlanderComments.doExternalLogout( 'twitter' );">Sair</a>&nbsp;/&nbsp;<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#" onclick="javascript:HighlanderComments.switchAccount();return false;">Alterar</a>&nbsp;)</span></p>
			</div>
	
		</div>
	</div>

	<div id="comment-form-facebook" class="comment-form-service">
		<div class="comment-form-padder">
			<div class="comment-form-avatar">
				<img src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/ad516503a11cd5ca435acc9bb6523536" alt="Foto do Facebook" width="25" class="no-grav">
			</div>

				<div class="comment-form-fields">
				<input type="hidden" name="fb_avatar" id="facebook-avatar" class="comment-meta-facebook" value="">
				<input type="hidden" name="fb_user_id" id="facebook-user_id" class="comment-meta-facebook" value="">
				<input type="hidden" name="fb_access_token" id="facebook-access_token" class="comment-meta-facebook" value="">
				<p class="comment-form-posting-as pa-facebook"><strong></strong> You are commenting using your Facebook account. <span class="comment-form-log-out">(&nbsp;<a href="javascript:HighlanderComments.doExternalLogout( 'facebook' );">Sair</a>&nbsp;/&nbsp;<a href="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/#" onclick="javascript:HighlanderComments.switchAccount();return false;">Alterar</a>&nbsp;)</span></p>
			</div>
	
		</div>
	</div>


	<div id="comment-form-load-service" class="comment-form-service">
		<div class="comment-form-posting-as-cancel"><a href="javascript:HighlanderComments.cancelExternalWindow();">Cancelar</a></div>
		<p>Connecting to %s</p>
	</div>
	
	
</div>

<script type="text/javascript">
jQuery(document).ready(function(){
	var input = document.createElement( 'input' ),
	    comment = jQuery( '#comment' );

	if ( 'placeholder' in input ) {
		comment.attr( 'placeholder', jQuery( '.comment-textarea label' ).remove().text() );
	}

	// Expando Mode: start small, then auto-resize on first click + text length
	jQuery( '#comment-form-identity' ).hide();
	jQuery( '#comment-form-subscribe' ).hide();
	jQuery( '#commentform .form-submit' ).hide();

	comment.css( { 'height':'10px' } ).one( 'focus', function() {
		var timer = setInterval( HighlanderComments.resizeCallback, 10 )
		jQuery( this ).animate( { 'height': HighlanderComments.initialHeight } ).delay( 100 ).queue( function(n) { clearInterval( timer ); HighlanderComments.resizeCallback(); n(); } );
		jQuery( '#comment-form-identity' ).slideDown();
		jQuery( '#comment-form-subscribe' ).slideDown();
		jQuery( '#commentform .form-submit' ).slideDown();
	});
});
</script>

<div id="comment-form-subscribe" style="display: none;"> 
	<p class="comment-subscription-form"><input type="checkbox" name="subscribe" id="subscribe" value="subscribe" style="width: auto;" tabindex="6"> <label class="subscribe-label" id="subscribe-label" for="subscribe">Notificar-me os comentários mais recentes via e-mail.</label></p></div>

												<p class="form-submit" style="display: none;">
							<input name="submit" type="submit" id="comment-submit" value="Publicar comentário">
							<input type="hidden" name="comment_post_ID" value="44" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
						</p>
						
<input type="hidden" name="genseq" value="1353893185">
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="9086ba03db"></p><script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/form.js"></script>
<p style="display: none;"><input type="hidden" id="ak_js" name="ak_js" value="1353893188292"></p>					</form>
							</div><!-- #respond -->
			<div style="clear: both"></div>			
		
	<!-- nothing found -->
	
	</div>

	<hr style="display:none">

	<!-- sidebar -->
	
	<div id="sidebar">
				<div>
		<div id="search-2" class="widget widget_search"><form method="get" id="searchform" action="http://alberane.wordpress.com/">
<p>
<input size="12" type="text" value="" name="s" id="s"><input class="btn" type="submit" id="searchsubmit" value="Pesquisa">
</p>
</form>
</div><div id="categories-1" class="widget widget_categories"><h2 class="title">Categorias</h2>		<ul>
			<li class="cat-item cat-item-25920"><a href="http://alberane.wordpress.com/category/artigos/" title="Artigos sem tema definido.">Artigos</a> (6)
</li>
	<li class="cat-item cat-item-5718"><a href="http://alberane.wordpress.com/category/curiosidades/" title="Ver todos os posts arquivados em Curiosidades">Curiosidades</a> (1)
</li>
	<li class="cat-item cat-item-3588"><a href="http://alberane.wordpress.com/category/freebsd/" title="Ver todos os posts arquivados em FreeBSD">FreeBSD</a> (1)
</li>
	<li class="cat-item cat-item-434022"><a href="http://alberane.wordpress.com/category/ginga/" title="Ver todos os posts arquivados em Ginga">Ginga</a> (2)
</li>
	<li class="cat-item cat-item-610"><a href="http://alberane.wordpress.com/category/tutoriais/linux/" title="Tutoriais de Linux.">Linux</a> (3)
</li>
	<li class="cat-item cat-item-2729669"><a href="http://alberane.wordpress.com/category/tutoriais/php-cakephp/" title="Ver todos os posts arquivados em PHP CakePHP">PHP CakePHP</a> (1)
</li>
	<li class="cat-item cat-item-5886"><a href="http://alberane.wordpress.com/category/programas/" title="Dicas de softwares em geral.">Programas</a> (2)
</li>
	<li class="cat-item cat-item-24549"><a href="http://alberane.wordpress.com/category/tutoriais/redes/" title="Tutoriais de Redes.">Redes</a> (3)
</li>
	<li class="cat-item cat-item-15896"><a href="http://alberane.wordpress.com/category/tutoriais/" title="Tutoriais sobre Hardware, Redes, Servidores Windows, Linux, PHP, Tableless e Web Standards.">Tutoriais</a> (5)
</li>
	<li class="cat-item cat-item-8074181"><a href="http://alberane.wordpress.com/category/xp-extreme-programming/" title="Ver todos os posts arquivados em XP Extreme Programming">XP Extreme Programming</a> (1)
</li>
		</ul>
</div><div id="calendar-2" class="widget widget_calendar"><h2 class="title">Posts Atuais</h2><div id="calendar_wrap"><table id="wp-calendar">
	<caption>maio 2009</caption>
	<thead>
	<tr>
		<th scope="col" title="segunda-feira">S</th>
		<th scope="col" title="terça-feira">T</th>
		<th scope="col" title="quarta-feira">Q</th>
		<th scope="col" title="quinta-feira">Q</th>
		<th scope="col" title="sexta-feira">S</th>
		<th scope="col" title="sábado">S</th>
		<th scope="col" title="domingo">D</th>
	</tr>
	</thead>

	<tfoot>
	<tr>
		<td colspan="3" id="prev"><a href="http://alberane.wordpress.com/2009/03/" title="Ver posts de março 2009">« mar</a></td>
		<td class="pad">&nbsp;</td>
		<td colspan="3" id="next"><a href="http://alberane.wordpress.com/2010/01/" title="Ver posts de janeiro 2010">jan »</a></td>
	</tr>
	</tfoot>

	<tbody>
	<tr>
		<td colspan="4" class="pad">&nbsp;</td><td>1</td><td>2</td><td>3</td>
	</tr>
	<tr>
		<td>4</td><td>5</td><td>6</td><td>7</td><td><a href="http://alberane.wordpress.com/2009/05/08/" title="Executando comandos SQL no CakePHP">8</a></td><td>9</td><td>10</td>
	</tr>
	<tr>
		<td>11</td><td>12</td><td>13</td><td>14</td><td>15</td><td>16</td><td>17</td>
	</tr>
	<tr>
		<td>18</td><td>19</td><td>20</td><td>21</td><td>22</td><td>23</td><td>24</td>
	</tr>
	<tr>
		<td>25</td><td>26</td><td>27</td><td>28</td><td>29</td><td>30</td><td>31</td>
	</tr>
	</tbody>
	</table></div></div><div id="archives-2" class="widget widget_archive"><h2 class="title">Posts Anteriores</h2>		<ul>
			<li><a href="http://alberane.wordpress.com/2010/08/" title="agosto 2010">agosto 2010</a>&nbsp;(1)</li>
	<li><a href="http://alberane.wordpress.com/2010/01/" title="janeiro 2010">janeiro 2010</a>&nbsp;(1)</li>
	<li><a href="http://alberane.wordpress.com/2009/05/" title="maio 2009">maio 2009</a>&nbsp;(1)</li>
	<li><a href="http://alberane.wordpress.com/2009/03/" title="março 2009">março 2009</a>&nbsp;(4)</li>
	<li><a href="http://alberane.wordpress.com/2008/06/" title="junho 2008">junho 2008</a>&nbsp;(1)</li>
	<li><a href="http://alberane.wordpress.com/2008/02/" title="fevereiro 2008">fevereiro 2008</a>&nbsp;(2)</li>
	<li><a href="http://alberane.wordpress.com/2008/01/" title="janeiro 2008">janeiro 2008</a>&nbsp;(2)</li>
	<li><a href="http://alberane.wordpress.com/2007/10/" title="outubro 2007">outubro 2007</a>&nbsp;(2)</li>
	<li><a href="http://alberane.wordpress.com/2007/07/" title="julho 2007">julho 2007</a>&nbsp;(1)</li>
	<li><a href="http://alberane.wordpress.com/2007/06/" title="junho 2007">junho 2007</a>&nbsp;(2)</li>
		</ul>
</div><div id="tag_cloud" class="widget widget_tag_cloud"><h2 class="title">Assuntos</h2><div style="overflow: hidden"><a href="http://alberane.wordpress.com/category/artigos/" style="font-size: 275%; padding: 1px; margin: 1px;" title="Artigos (6)">Artigos</a> <a href="http://alberane.wordpress.com/category/curiosidades/" style="font-size: 100%; padding: 1px; margin: 1px;" title="Curiosidades (1)">Curiosidades</a> <a href="http://alberane.wordpress.com/category/freebsd/" style="font-size: 100%; padding: 1px; margin: 1px;" title="FreeBSD (1)">FreeBSD</a> <a href="http://alberane.wordpress.com/category/ginga/" style="font-size: 135%; padding: 1px; margin: 1px;" title="Ginga (2)">Ginga</a> <a href="http://alberane.wordpress.com/category/tutoriais/linux/" style="font-size: 170%; padding: 1px; margin: 1px;" title="Linux (3)">Linux</a> <a href="http://alberane.wordpress.com/category/tutoriais/php-cakephp/" style="font-size: 100%; padding: 1px; margin: 1px;" title="PHP CakePHP (1)">PHP CakePHP</a> <a href="http://alberane.wordpress.com/category/programas/" style="font-size: 135%; padding: 1px; margin: 1px;" title="Programas (2)">Programas</a> <a href="http://alberane.wordpress.com/category/tutoriais/redes/" style="font-size: 170%; padding: 1px; margin: 1px;" title="Redes (3)">Redes</a> <a href="http://alberane.wordpress.com/category/tutoriais/" style="font-size: 240%; padding: 1px; margin: 1px;" title="Tutoriais (5)">Tutoriais</a> <a href="http://alberane.wordpress.com/category/xp-extreme-programming/" style="font-size: 100%; padding: 1px; margin: 1px;" title="XP Extreme Programming (1)">XP Extreme Programming</a> </div></div><div id="wp_tag_cloud" class="widget wp_widget_tag_cloud"><h2 class="title">Tags</h2><div style="overflow:hidden"><a href="http://alberane.wordpress.com/tag/alberane/" class="tag-link-17582346" title="1 tópico" style="font-size: 8pt;">Alberane</a>
<a href="http://alberane.wordpress.com/tag/aulas/" class="tag-link-139394" title="1 tópico" style="font-size: 8pt;">Aulas</a>
<a href="http://alberane.wordpress.com/tag/avast/" class="tag-link-338034" title="1 tópico" style="font-size: 8pt;">Avast</a>
<a href="http://alberane.wordpress.com/tag/beep/" class="tag-link-709050" title="1 tópico" style="font-size: 8pt;">beep</a>
<a href="http://alberane.wordpress.com/tag/charset/" class="tag-link-299628" title="1 tópico" style="font-size: 8pt;">Charset</a>
<a href="http://alberane.wordpress.com/tag/ginga/" class="tag-link-434022" title="1 tópico" style="font-size: 8pt;">Ginga</a>
<a href="http://alberane.wordpress.com/tag/ginga-ncl/" class="tag-link-4360236" title="1 tópico" style="font-size: 8pt;">Ginga-NCL</a>
<a href="http://alberane.wordpress.com/tag/iso8859-1/" class="tag-link-2714373" title="1 tópico" style="font-size: 8pt;">ISO8859-1</a>
<a href="http://alberane.wordpress.com/tag/linux/" class="tag-link-610" title="2 tópicos" style="font-size: 22pt;">Linux</a>
<a href="http://alberane.wordpress.com/tag/logon/" class="tag-link-601243" title="1 tópico" style="font-size: 8pt;">logon</a>
<a href="http://alberane.wordpress.com/tag/mysql/" class="tag-link-4419" title="1 tópico" style="font-size: 8pt;">Mysql</a>
<a href="http://alberane.wordpress.com/tag/ncl/" class="tag-link-315296" title="1 tópico" style="font-size: 8pt;">NCL</a>
<a href="http://alberane.wordpress.com/tag/osi/" class="tag-link-338757" title="1 tópico" style="font-size: 8pt;">OSI</a>
<a href="http://alberane.wordpress.com/tag/php/" class="tag-link-458" title="1 tópico" style="font-size: 8pt;">PHP</a>
<a href="http://alberane.wordpress.com/tag/prompt/" class="tag-link-253250" title="1 tópico" style="font-size: 8pt;">prompt</a>
<a href="http://alberane.wordpress.com/tag/redes/" class="tag-link-24549" title="1 tópico" style="font-size: 8pt;">Redes</a>
<a href="http://alberane.wordpress.com/tag/set-names/" class="tag-link-4785000" title="1 tópico" style="font-size: 8pt;">SET NAMES</a>
<a href="http://alberane.wordpress.com/tag/tv-digital/" class="tag-link-145725" title="1 tópico" style="font-size: 8pt;">TV Digital</a>
<a href="http://alberane.wordpress.com/tag/ubuntu/" class="tag-link-255" title="1 tópico" style="font-size: 8pt;">Ubuntu</a>
<a href="http://alberane.wordpress.com/tag/usabilidade/" class="tag-link-6134" title="1 tópico" style="font-size: 8pt;">Usabilidade</a>
<a href="http://alberane.wordpress.com/tag/utf-8/" class="tag-link-241625" title="1 tópico" style="font-size: 8pt;">UTF-8</a>
<a href="http://alberane.wordpress.com/tag/web-standars/" class="tag-link-2185371" title="1 tópico" style="font-size: 8pt;">Web Standars</a>
<a href="http://alberane.wordpress.com/tag/windows-98/" class="tag-link-52064" title="1 tópico" style="font-size: 8pt;">Windows 98</a>
<a href="http://alberane.wordpress.com/tag/xp-extreme-programming/" class="tag-link-8074181" title="1 tópico" style="font-size: 8pt;">XP Extreme Programming</a></div></div><div id="twitter-2" class="widget widget_twitter"><h2 class="title"><a href="http://twitter.com/alberane">Twitter</a></h2><ul class="tweets">
			<li>
				@<a href="http://twitter.com/rodrigorenault">rodrigorenault</a> Cara... você ainda pertence a esse plano?!? Parabéns.. acho que foi seu aniversário ontem né.... :) t+ 				<a href="http://twitter.com/alberane/statuses/264437988539387904" class="timesince">3&nbsp;weeks&nbsp;ago</a>
			</li>

			
			<li>
				Fala pessoal! Retomando as atividades com Twitter... estou de volta! depois de bastante tempo! 				<a href="http://twitter.com/alberane/statuses/258241429598511104" class="timesince">1&nbsp;month&nbsp;ago</a>
			</li>

			
			<li>
				A partir e hoje, 45% das piadas sobre TV terão que ser reescritas... :) <a href="http://twitter.com/search?q=%23Hebe">#Hebe</a> 				<a href="http://twitter.com/alberane/statuses/252117410335817728" class="timesince">1&nbsp;month&nbsp;ago</a>
			</li>

			
			<li>
				Conheça o candidato Rômulo 20.000 <a href="http://twitter.com/search?q=%23liberdade">#liberdade</a>-mg <a href="http://wp.me/P2KBKQ-6"> wp.me/P2KBKQ-6</a> 				<a href="http://twitter.com/alberane/statuses/248944598339174400" class="timesince">2&nbsp;months&nbsp;ago</a>
			</li>

			
			<li>
				Olá Ricardo, rsrs verdade.... vou postar um screencast com a configuração no wi (@<a href="http://twitter.com/YouTube">YouTube</a> <a href="http://youtu.be/AwJteD9E9sg?a"> youtu.be/AwJteD9E9sg?a</a>) 				<a href="http://twitter.com/alberane/statuses/246708556437544960" class="timesince">2&nbsp;months&nbsp;ago</a>
			</li>

			</ul></div>		<div id="blog-stats" class="widget widget_statscounter">			<h2 class="title">Estatísticas</h2>			<ul>
			<li>13,634 Pessoas já estiviram aqui!</li>
			</ul>
		</div>		</div>
	</div>

	<br style="clear:both"><!-- without this little <br /> NS6 and IE5PC do not stretch the frame div down to encopass the content DIVs -->
</div>

<!-- footer -->

		<hr style="display:none">

		<div id="footer">
			<small class="footer_content">
			<a href="http://pt-br.wordpress.com/?ref=footer" rel="generator">Blog no WordPress.com</a>. Tema: Freshy por <a href="http://www.jide.fr/" rel="designer">Jide</a>. 			</small>
		</div>

	</div> <!--- end of the <div id="wrapper"> (from header.php) -->
</div> <!--- end of the <div id="page"> (from header.php) -->


<script type="text/javascript">
var _qevents = _qevents || [], wpcomQuantcastData = {"qacct":"p-18-mFEk4J448M","labels":",language.pt-br,type.wpcom,as"};
function wpcomQuantcastPixel( labels, options ) {
	var i, defaults = wpcomQuantcastData, data = { event: 'ajax' };

	labels  = labels  || '';
	options = options || {};

	if ( typeof labels != 'string' )
		options = labels;

	for ( i in defaults ) {
		data[i] = defaults[i];
	}

	for ( i in options ) {
		data[i] = options[i];
	}

	if ( data.labels ) {
		data.labels += ',' + labels;
	} else {
		data.labels = labels;
	}

	_qevents.push( data );
};
(function() {var elem = document.createElement('script');elem.src = (document.location.protocol == "https:" ? "https://secure" : "http://edge") + ".quantserve.com/quant.js";elem.async = true;elem.type = "text/javascript";var scpt = document.getElementsByTagName('script')[0];scpt.parentNode.insertBefore(elem, scpt);  })();
_qevents.push( wpcomQuantcastData );
</script>
<noscript>&lt;div style="display: none;"&gt;&lt;img src="//pixel.quantserve.com/pixel/p-18-mFEk4J448M.gif?labels=%2Clanguage.pt-br%2Ctype.wpcom%2Cas" height="1" width="1" alt="" /&gt;&lt;/div&gt;</noscript>


	<script type="text/javascript">
	/* <![CDATA[ */
	(function($){
		$(document).on( 'ready post-load', function() {

			// Remove the login box when clicking the page
			$( document ).mousedown( function( e ) {
				if ( null == $( e.target ).closest( '#wpl-mustlogin' ).get( 0 ) ) {
					$( '#wpl-mustlogin' ).remove();
				}
			});

			// Handle clicking the like button itself
			$('.wpl-button > a.like').click( function(e) {
				e.preventDefault();

				var postid = $(this).parent().attr('id').split('like-')[1];
				$.post( 'http://alberane.wordpress.com/wp-admin/admin-ajax.php', {
					'action': 'wpl_record_stat',
					'stat_name': 'loggedout_like_click'
				} );

				var tenMins = new Date();
				tenMins.setTime( tenMins.getTime() + 600000 );
				document.cookie = 'wpl_rand=d0a497cf0d; expires=' + tenMins.toGMTString() + '; domain=wordpress.com; path=/;';

				$(this).parent().siblings('.wpl-count').after( '\
					<div id="wpl-mustlogin"> \
						<form action="https://alberane.wordpress.com/wp-login.php" method="post"> \
							<p>Just one more step to like this:</p> \
							<label><span>Nome de usuário</span> <input type="text" name="log" id="user_login" class="input" value="" size="20" tabindex="80" /></label> \
							<label><span>Senha</span> <input type="password" name="pwd" id="user_pass" class="input" value="" size="20" tabindex="81" /></label> \
							<input type="submit" name="wp-submit" id="wp-submit" class="button-primary" value="Login" tabindex="82" /> \
							<input type="hidden" name="postid" value="' + postid + '" /> \
							<input type="hidden" name="redirect_to" value="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp?year=2009&#038;monthnum=05&#038;day=08&#038;name=executando-comandos-sql-no-cakephp&#038;like=1" /> \
							<input type="hidden" name="wpl_rand" value="d0a497cf0d" /> \
							<p>Not a member yet? <a href="http://wordpress.com/signup/?ref=likebox&user=1" id="wpl-signup-link">Registre-se no WordPress.com grátis</a></p> \
						</form> \
					</div> \
				');

				$('#wpl-mustlogin').hide().slideDown('fast');
			} );

			$('#wpl-mustlogin input.input').live( 'focus', function() {
				$(this).prev().hide();
			}).live( 'blur', function() {
				if ( $(this).val() == '' ) {
					$(this).prev().show();
				}
			});

			$('#wpl-mustlogin input#wp-submit').live( 'click', function(e) {
				e.preventDefault();

				$.post( 'http://alberane.wordpress.com/wp-admin/admin-ajax.php', {
					'action': 'wpl_record_stat',
					'stat_name': 'loggedout_login_submit'
				}, function() {
					$('#wpl-mustlogin form').submit();
				} );
			});

			$('#wpl-mustlogin a#wpl-signup-link').live( 'click', function(e) {
				e.preventDefault();

				var link = $(this).attr('href');

				$.post( 'http://alberane.wordpress.com/wp-admin/admin-ajax.php', {
					'action': 'wpl_record_stat',
					'stat_name': 'loggedout_signup_click'
				}, function() {
					location.href = link;
				} );
			});
		})
	})(jQuery);
	/* ]]> */
	</script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/gprofiles.js"></script>
<script type="text/javascript">
/* <![CDATA[ */
var WPGroHo = {"my_hash":""};
/* ]]> */
</script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/wpgroho.js"></script>
<script>jQuery(document).ready(function($){ Gravatar.profile_cb = function( h, d ) { WPGroHo.syncProfileData( h, d );	}; Gravatar.my_hash = WPGroHo.my_hash; Gravatar.init( 'body', '#wp-admin-bar-my-account' ); });</script>	<div style="display:none">
	<div class="grofile-hash-map-6d14de4f8a572b54ec67d34ee92bf742">
	</div>
	<div class="grofile-hash-map-a4e4fd831fad341f603d6d3c3516e753">
	</div>
	<div class="grofile-hash-map-13afd943e915547000950ea34bf67de1">
	</div>
	</div>
<script type="text/javascript">
/* <![CDATA[ */
var HighlanderComments = {"loggingInText":"Logging In\u2026","submittingText":"Posting Comment\u2026","postCommentText":"Publicar coment\u00e1rio","connectingToText":"Connecting to %s","commentingAsText":"%1$s: You are commenting using your %2$s account.","logoutText":"Sair","loginText":"Login","connectURL":"http:\/\/alberane.wordpress.com\/public.api\/connect\/?action=request","logoutURL":"http:\/\/alberane.wordpress.com\/wp-login.php?action=logout&_wpnonce=2f0a0d10e4","homeURL":"http:\/\/alberane.wordpress.com\/","postID":"44","gravDefault":"identicon","enterACommentError":"Por favor escreva um coment\u00e1rio","enterEmailError":"Please enter your email address here","invalidEmailError":"Email inv\u00e1lido","enterAuthorError":"Please enter your name here","gravatarFromEmail":"This picture will show whenever you leave a comment. Click to customize it.","logInToExternalAccount":"Fa\u00e7a login para usar detalhes de uma de suas conta.","change":"Alterar","changeAccount":"Alterar Conta","comment_registration":"","userIsLoggedIn":"","isJetpack":"0"};
/* ]]> */
</script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/script.js"></script>

	<div id="bit" class="loggedout-follow-normal" style="bottom: -226px;">
		<a class="bsub" href="javascript:void(0)"><span id="bsub-text">Seguir</span></a>
		<div id="bitsubscribe">

					<h3><label for="loggedout-follow-field">Follow “Alberane Lúcio”</label></h3>

			<form action="https://subscribe.wordpress.com/" method="post" accept-charset="utf-8" id="loggedout-follow">
			<p>Obtenha todo post novo entregue na sua caixa de entrada.</p>

			<p id="loggedout-follow-error" style="display: none;"></p>

			
			<p><input type="email" name="email" style="width: 95%; padding: 1px 2px" value="Enter your email address" onfocus="this.value=(this.value==&quot;Enter your email address&quot;) ? &quot;&quot; : this.value;" onblur="this.value=(this.value==&quot;&quot;) ? &quot;Enter email address&quot; : this.value;" id="loggedout-follow-field"></p>

			<input type="hidden" name="action" value="subscribe">
			<input type="hidden" name="blog_id" value="484880">
			<input type="hidden" name="source" value="http://alberane.wordpress.com/2009/05/08/executando-comandos-sql-no-cakephp/">
			<input type="hidden" name="sub-type" value="loggedout-follow">

			<input type="hidden" id="_wpnonce" name="_wpnonce" value="b4646de387"><input type="hidden" name="_wp_http_referer" value="/2009/05/08/executando-comandos-sql-no-cakephp/">
			<p id="bsub-subscribe-button"><input type="submit" value="Sign me up"></p>
			</form>
					<div id="bsub-credit"><a href="http://wordpress.com/signup/?ref=lof">Powered by WordPress.com</a></div>
		</div><!-- #bitsubscribe -->
	</div><!-- #bit -->
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/widgets.js"></script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/beacon.js"></script><script type="text/javascript">try{COMSCORE.beacon({c1:2,c2:7518284});}catch(e){}</script><noscript>&lt;p class="robots-nocontent"&gt;&lt;img src="http://b.scorecardresearch.com/p?cj=1c1=2&amp;#038;c2=7518284" alt="" style="display:none" width="1" height="1" /&gt;&lt;/p&gt;</noscript><script type="text/javascript">
/* <![CDATA[ */
var thickboxL10n = {"next":"Pr\u00f3ximo \u00bb","prev":"\u00ab Anterior","image":"Imagem","of":"de","close":"Fechar","noiframes":"Este recurso necessita frames em linha. Os iframes est\u00e3o desativados por voc\u00ea ou seu navegador n\u00e3o os suporta.","loadingAnimation":"http:\/\/alberane.wordpress.com\/wp-includes\/js\/thickbox\/loadingAnimation.gif","closeImage":"http:\/\/alberane.wordpress.com\/wp-includes\/js\/thickbox\/tb-close.png"};
var thickboxL10n = {"next":"Pr\u00f3ximo \u00bb","prev":"\u00ab Anterior","image":"Imagem","of":"de","close":"Fechar","noiframes":"Este recurso necessita frames em linha. Os iframes est\u00e3o desativados por voc\u00ea ou seu navegador n\u00e3o os suporta.","loadingAnimation":"http:\/\/alberane.wordpress.com\/wp-includes\/js\/thickbox\/loadingAnimation.gif","closeImage":"http:\/\/alberane.wordpress.com\/wp-includes\/js\/thickbox\/tb-close.png"};
/* ]]> */
</script>
<script type="text/javascript" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/saved_resource(2)"></script>
<script type="text/javascript">
// <![CDATA[
(function() {
try{
  if ( window.external &&'msIsSiteMode' in window.external) {
    if (window.external.msIsSiteMode()) {
      var jl = document.createElement('script');
      jl.type='text/javascript';
      jl.async=true;
      jl.src='/wp-content/plugins/ie-sitemode/custom-jumplist.php';
      var s = document.getElementsByTagName('script')[0];
      s.parentNode.insertBefore(jl, s);
    }
  }
}catch(e){}
})();
// ]]>
</script><script src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/w.js" type="text/javascript"></script>
<script type="text/javascript">
st_go({'blog':'484880','v':'wpcom','user_id':'0','post':'44','subd':'alberane'});
ex_go({'crypt':'UE5XaGUuOTlwaD85flAmcm1mcmZsaDhkV11YdWFnNncxc1tjZG9XVXhRW3J8TyVnZTFjeVYyWnlIT1Rlflo9TWt6flJxNTNbZG1KZmRoTnN2eix3QlFKJklMTm00P0Q/N2pMUW5PWjc4OFUyQlZmT35RM21bSkImX2NtW09DbDlsUFc2OFdrV3pLa10uPXd2NlZNbjhiam5SOVF3Yz00azJwbXlWZ21wcWVmTGVaYlJJJUZzai9uW3JUWT1HS0tDYmdDNSZqZDlRUz1PLHQ3USxbeFJXZkgsNS9+aFU/bHYzS1hqdDducXNnSThEMVgrczRNVlFrNHVyX1dkZ1RTN3pzcnZFZHlpW340WEhDOWc5Z2VdVHFRWDF6WDVIUC9zZ01l'});
addLoadEvent(function(){linktracker_init('484880',44);});
	</script><img id="wpstats" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/g.gif" alt=""><img id="wpstats2" src="./Executando comandos SQL no CakePHP « Alberane Lúcio_files/g(1).gif" alt="" style="display:none">
<noscript>&lt;img src="http://stats.wordpress.com/b.gif?v=noscript" style="height:0px;width:0px;overflow:hidden" alt="" /&gt;</noscript>


</body></html>